package com.yonyou.gmmc.service.pointactivity.dao;
import com.yonyou.gmmc.common.annotation.OracleDb;
import com.yonyou.gmmc.service.pointactivity.model.*;
import org.springframework.beans.factory.annotation.Autowired;
import tk.mybatis.mapper.common.Mapper;

import java.util.Date;
import java.util.List;
import java.util.Map;

@OracleDb
public interface TtWinnerRecordMapper extends Mapper<TtWinnerRecord> {
    /**
     * 根据日期查询抽奖纪录
     * @param recorddate
     * @return
     */
    public List<Map<String,Object>> queryWinnerRecordByDate(String recorddate);

    /**
     *
     * @param ttWinnerRecord
     * @return
     */
    public int insertWinnerRecord(TtWinnerRecord ttWinnerRecord);

    /**
     * 根据openid查询车架号
     * @param openid
     * @return
     */
    public String queryVIN(String openid);
    public void recordVisit(Map<String, Object> param);

    /**
     * 根据车架号查询抽奖纪录
     *
     * @return
     */
    public int queryRecordByVIN(Map<String,Object> maps);

    /**
     * 查询统计报表
     * @return
     */
    public List<PrizeCountBo> queryRecordReport();

    /**
     * 根据openid查找用户
     * @param openid
     * @return
     */
    public String queryUserByOpenid(String openid);
    public String queryDiffDateStart();
    public String queryDiffDateEnd();

    /**
     * 保存收到的手机验证码
     * @param tmFiveYearFeedMsg
     */
    public void saveYearFeedMsg(TmFiveYearFeedMsg tmFiveYearFeedMsg);

    /**
     * 获取短信验证码时间
     * @param openId
     */
    public TmFiveYearFeedMsg queryMsgSencond(String openId);

    /**
     * 根据openid查询留资信息
     * @param openId
     * @return
     */
    public TmKeep queryTmkeep(String openId);

    public List<TmKeepCountVo> queryTmKeepCountByDate();
}
